I have two lists I am trying to reconcile and return unmatched values I am trying to find matches from column B on the office log column F. If there is a match, I would t…

0 Updates 1 Recommended Answer 6 Replies 0 Upvotes

Calculating Time Interval - format issue I'm trying to calculate time intervals. I have a sample sheet here: https://docs.google.com/spreadsh…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

Fill cells with values based on value chosen in another cell I'm not particularly good with Google functions and would really appreciate some help with these thi…

0 Updates 1 Recommended Answer 2 Replies 0 Upvotes

GOOGLEFINANCE Function is not inporting the REIT stock price of the TASI MARKET I am using google sheet to track my stocks and dividends, and i am using the GOOGLEFINANCE function …

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

Sum of transactions on certain days of the week Hello everyone! I am trying to create some kind of formula or chart that will display £ taken on spe…

0 Updates 0 Recommended Answers 2 Replies 0 Upvotes

Editors able to edit protected ranges using scripts on google sheets I have editor access to a spreadsheet and cannot access some cells due to protected ranges. However,…

0 Updates 0 Recommended Answers 1 Relevant Answer 2 Replies 0 Upvotes

Cant add more decimal places to the percentages of my pie chart. Please help omg this is so frustrating. I just want to know how do I edit the percentage of my pie c…

0 Updates 0 Recommended Answers 1 Relevant Answer 3 Replies 0 Upvotes

Return data list based on cell contents Hi, I am currently trying to build a make-shift database in sheets for service users for a charity t…

0 Updates 0 Recommended Answers 4 Replies 0 Upvotes

If with AND and vlookup Hi All, Struggling with this one Sheet SalesInvoice from order, BQ I need to match 2 values, make su…

0 Updates 1 Recommended Answer 3 Replies 0 Upvotes

How to filter the data with some keywords met (in OR condition, any keyword found will be filter out Data example ID Group 1 AA 2 BB 3 CC 4 AA 5 AA/BB 6 CC/DD 7 DD 8 BB/AA 9 AA/CC 10 AA/BB/DD 11 CC/AA …

0 Updates 1 Recommended Answer 4 Replies 0 Upvotes

Add column/row to range and fill with values I'm using IMPORTRANGE to consolidate data from numerous workbooks. Ideally, I'd like to be able to g…

0 Updates 1 Recommended Answer 3 Replies 0 Upvotes

I have a sheet that is populated on daily basis. I want a row to auto move up once is marked treated I have a sheet that is populated on daily basis. I want a row to auto move up once is marked treated

0 Updates 0 Recommended Answers 2 Replies 0 Upvotes

Create a list of unchecked items I'm creating a packing list for a music festival and would like to see what I haven't yet purchased …

0 Updates 1 Recommended Answer 5 Replies 0 Upvotes

Problem with a IFERROR VLOOKUP formula Hi there I have been given editing perms on a google doc we have a formula that is only working till…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

Create a button that moves to a specified cell I have a large data table (lets say B1:AE200) and a single dynamic/variable cell above it in A1 that…

0 Updates 0 Recommended Answers 15 Replies 0 Upvotes

I have permission to edit and access the sheet, but when using the IMPORTRANGE function it still say I have permission to edit and access the sheet, but when using the IMPORTRANGE function it still say

0 Updates 0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes

LOOKUP type formula Hi All, hoping that someone can help with what formula(s) are needed to get a spreadsheet working. I…

0 Updates 0 Recommended Answers 4 Replies 0 Upvotes

sheet do no populate with squarespace form inputs I Cannot get the sheets to receive input from squarespace forms

0 Updates 0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes

Looking for someone that can script Me and my team work with medication a lot especially inventory. We are looking for help create a cod…

0 Updates 0 Recommended Answers 1 Relevant Answer 2 Replies 0 Upvotes

getRange is not a function Hi all, Please help, getting this error TypeError: "SalesInvoice from Order".getRange is not a funct…

0 Updates 0 Recommended Answers 6 Replies 0 Upvotes